This Analysis Model is used for: Inventory. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
Main analysis scenarios are:
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| INVENTORY TURNOVER MEASURES | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER | On Line |
| INVENTORY VALUE MEASURES | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE | On Line |
| INVENTORY TRANSACTION HISTORY MEASURES | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST | On Line |
| CURRENCY RATES | FACT_CURRENCY_RATES_BI | FACT_CURRENCY_RATES | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
FACT_INVENT_TRANS_HIST
The main purpose of this information source is to present data based on the inventory transactions history to support high level summarizations and analyzes to evaluate changes in inventory, for instance, using the Count metrics.
FACT_INVENTORY_TURNOVER
The main purpose of this information source is to present data based on the average issues connected to the receipts per period to support high level summarizations and analyses to evaluate inventory quantities, movements and turnover rates.
FACT_INVENTORY_VALUE
The main purpose of this information source is to present data based on the inventory values per period to support high level summarizations and analyses to evaluate changes of inventory values in different perspectives.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CONDITION CODE | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE | On Line |
| PLANNER | DIM_PLANNER_BI | DIM_PLANNER | On Line |
| INVENTORY LOCATION | DIM_INVENTORY_LOCATION_BI | DIM_INVENTORY_LOCATION | On Line |
| INVENTORY PART | DIM_INVENTORY_PART_BI | DIM_INVENTORY_PART | On Line |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_PQ_BI | DIM_REPORTING_CURRENCY_PQ | On Line |
| SITE | DIM_SITE_BI | DIM_SITE | On Line |
| COMMODITY GROUP | DIM_COMMODITY_GROUP_BI | DIM_COMMODITY_GROUP | On Line |
| MPCCOM TRANSACTION CODE | DIM_MPCCOM_TRANSACTION_CODE_BI | DIM_MPCCOM_TRANSACTION_CODE | On Line |
| RETURN CAUSE | DIM_RETURN_CAUSE_BI | DIM_RETURN_CAUSE | On Line |
| SCRAPPING CAUSE | DIM_SCRAPPING_CAUSE_BI | DIM_SCRAPPING_CAUSE | On Line |
| STATISTIC PERIOD | DIM_STATISTIC_PERIOD_BI | DIM_STATISTIC_PERIOD | On Line |
| INVENTORY TRANSACTION HISTORY | FACT_INVENT_TRANS_HIST_BI | FACT_INVENT_TRANS_HIST_PQ | On Line |
| INVENTORY TURNOVER | FACT_INVENTORY_TURNOVER_BI | FACT_INVENTORY_TURNOVER_PQ | On Line |
| INVENTORY VALUE | FACT_INVENTORY_VALUE_BI | FACT_INVENTORY_VALUE_PQ | On Line |
| IT CREATED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ITH DATE APPLIED | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ITH DATE CREATED | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ITH EXPIRATION DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| IV DATE CREATED | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
The Tabular Model supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.
Please refer to Technical Documentation for more information.
Combinations of facts and dimensions that do not match will not give any results
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| INVENTORY VALUE (DIM_COMPANY_IS_ID) - COMPANY (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_SITE_IS_ID) - SITE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_RETURN_CAUSE_IS_ID) - RETURN CAUSE (ID) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_MPCCOM_TRANSACTION_CODE_ID) - MPCCOM TRANSACTION CODE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ITH_DATE_CREATED_ID) - ITH DATE CREATED (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_INVENTORY_LOCATION_ID) - INVENTORY LOCATION (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_SCRAPPING_CAUSE_ID) - SCRAPPING CAUSE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ITH_EXPIRATION_DATE_ID) - ITH EXPIRATION DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_ITH_DATE_APPLIED_ID) - ITH DATE APPLIED (ID) |
| INVENTORY VALUE (DIM_STATISTIC_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_STATISTIC_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY VALUE (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| INVENTORY VALUE (PLANNER_BUYER_NEW) - PLANNER (ID) |
| INVENTORY TURNOVER (PLANNER_BUYER_NEW) - PLANNER (ID) |
| INVENTORY TRANSACTION HISTORY (PLANNER_BUYER_NEW) - PLANNER (ID) |
| INVENTORY TURNOVER (DIM_STAT_PERIOD_ID) - STATISTIC PERIOD (ID) |
| INVENTORY TURNOVER (DIM_SECOND_COMMODITY_ID) - COMMODITY GROUP (ID) |
| INVENTORY TURNOVER (DIM_IT_DATE_CREATED_ID) - IT CREATED DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_PROJECT_ID) - PROJECT (ID) |
| INVENTORY TURNOVER (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| INVENTORY TURNOVER (DIM_SITE_ID) - SITE (ID) |
| INVENTORY VALUE (DIM_SITE_ID) - SITE (ID) |
| INVENTORY VALUE (IV_DATE_CREATED) - IV DATE CREATED (ID) |
| INVENTORY TURNOVER (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| INVENTORY VALUE (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |
| INVENTORY TRANSACTION HISTORY (DIM_REPORTING_DATE_ID) - REPORTING DATE (ID) |